One, wildcard charactersWildcard Description Example %: Matches any string that contains 0 or more characters。 The WHERE title like '%computer% ' will find all titles that contain the word computer anywhere in the title._ (Underscore): Match any
One, wildcard charactersWildcard Description Example%: Matches any string that contains 0 or more characters。 The WHERE title like '%computer% ' will find all titles that contain the word computer anywhere in the title._ (Underline): Matchany single
In Oracle , some characters represent a special meaning, such as a & symbol, that represents a variable substitution, and% represents a wildcard character during a queryHere are some word relabeled that have special meanings in ORACLE to test:
Ext.: http://blog.chinaunix.net/uid-26896647-id-3433968.htmlQuestion Description: If there are special characters such as ' & ', ' _ ', '% ' on a field in a table, and we have to use these special characters in the Where condition?1. Create a table
Oracle special character escape: & and ', oracle special character escapeWhen we run the SQL show all command in SQL * PLUS, we can find a parameter: define & (hex 26), as shown below:Concat. (hex 2e)Copycommit 0Copytypecheck ONDefine & (hex
First, what is an escape characterAn escape character is a special character constant, preceded by a backslash "\" followed by one or several characters. Have a specific meaning, different from the original meaning of the character, it is called
The following articles mainly introduce the Oracle insert escape characters, single quotation marks and & characters. If you think their names are weird, in addition, if they are rarely involved in practical applications, the following articles will
1, Oracle special character escapes keyword:oracle escape Environment: Oracle9i plsql Execute inside Plsql: Update userinfo set pageurl= ' myjsp?page=1&pagesize=10 ' where id= ' test ' This SQL
Search for fields
Search for fields
Find '%' in the field, which involves the escape characters of Oracle. The following is a summary:
SQL> select * from test;
TEST--------------------Sdd_kkD 'dDfsfsaDffa % asfs123451% 23451% 543212% 54321%
I. Insert the single quotation marks (single quotation marks) and the & Symbol in Oracle
When importing a batch of data to Oracle today, I encountered a problem: toad prompts me to assign a value to a custom variable amp. At first I was wondering
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.